vba array length

200

excel vba determine number of elements in an array - 

'Since VBA arrays can have ANY integer value (from -2147483648 to 
'2147483647) for the lower index in the range for a rank,
'the only sure fire way to determine how many elements is in the array
'is to calculate the value:

MsgBox UBound(Arr) - LBound(Arr) + 1		'<--for elems in 1D array

MsgBox UBound(Arr, 1) - LBound(Arr, 1) + 1	'<--for rows in 2D array
MsgBox UBound(Arr, 2) - LBound(Arr, 2) + 1	'<--for cols in 2D array

Comments

Submit
0 Comments

More Questions

vba array lengthvba code to remove duplicates from a column vba loop through files in folder
excel vba get the path of current workbookvba how to convert a column number into an Excel column excelvba check for directory
vba delete filevba check if file exists xlvba double quotes in string literal
xlvba check for folderxl vba double quotes in string literal excel formula how to create strings containing double quotes
excel vba copy values range to another rangexl vba check for folder excel-vba how to convert a column number into an excel column
VBA Loop through recordsetwrite to text file vb.net excel vba function to convert column number to letter
vba string to dateexcel vba wait vbs send keys
string to date vb excel vba check if directory exists
C
CSS
Objective-C
PHP
Java
C++
Javascript
Html
Python
SQL
Swift
Ruby
Go
R
TypeScript
Kotlin
Assembly
VBA
Scala
Rust
Elixir
Dart
Haskell
Perl
Fortran
Matlab
Scheme
Julia
Lua
Delphi
Pascal
Solidity
BASIC
ActionScript
Csharp